Real-time index concurrency control

Real time database systems are expected to rely heavily on indexes to speed up data access and thereby help more transactions meet their deadlines. Accordingly, high performance index concurrency control (ICC) protocols are required to prevent contention for the index from becoming a bottleneck. We develop real time variants of a representative set of classical B-tree ICC protocols and, using a detailed simulation model, compare their performance for real time transactions with firm deadlines. We also present and evaluate a real time ICC protocol called GUARD-link that augments the classical B-link protocol with a feedback based admission control mechanism. Both point and range queries, as well as the undos of the index action transactions are included in the study. The performance metrics used in evaluating the ICC protocols are the percentage of transactions that miss their deadlines and the fairness with respect to transaction type and size. Experimental results show that the performance characteristics of the real time version of an ICC protocol could be significantly different from the performance of the same protocol in a conventional (nonreal time) database system. In particular, B-link protocols, which are reputed to provide the best overall performance in conventional database systems, perform poorly under heavy real time loads. The new GUARD-link protocol, however, although based on the B-link approach, delivers the best performance (with respect to all performance metrics) for a variety of real time transaction workloads, by virtue of its admission control mechanism. GUARD-link provides close to ideal fairness in most environments     

Bubble Formation through Reaction at Liquid‐Liquid Interfaces

Slag foaming is an important phenomenon in steelmaking processes with both beneficial as well as negative effects. The present work is part of the wider project on the modelling of slag foaming, with special reference to dynamic conditions. Since bubble formation is the first step to foam formation, the present work was carried out in an attempt to simulate the bubble formation in slag/metal reactions in steelmaking processes by water‐modelling experiments. The bubble formation due to the gas produced through chemical reaction at the interface between oleic acid and sodium bicarbonate solution was systematically monitored. The chemical reaction rate was varied by varying the concentration of sodium bicarbonate. The bubbles were observed to be generated in the heavier aqueous phase just below the water‐oil interface. The bubbles penetrated the interface and escaped through the oil phase. The rate of the reaction was estimated from the volume of the gas that passed the water/oil interface. It was observed that the bubble formation and bubble growth mechanism were influenced by the reaction rate while the bubble size seemed to be unaffected by the reaction rate.     

Distributed Multi-Level Recovery in Main-Memory Databases

In this paper we present recovery techniques for distributed main-memory databases, specifically for client-server and shared-disk architectures. We present a recovery scheme for client-server architectures which is based on shipping log records to the server, and two recovery schemes for shared-disk architectures—one based on page shipping, and the other based on broadcasting of the log of updates. The schemes offer different tradeoffs, based on factors such as update rates.Our techniques are extensions to a distributed-memory setting of a centralized recovery scheme for main-memory databases, which has been implemented in the Dalì main-memory database system. Our centralized as well as distributed-memory recovery schemes have several attractive features—they support an explicit multi-level recovery abstraction for high concurrency, reduce disk I/O by writing only redo log records to disk during normal processing, and use per-transaction redo and undo logs to reduce contention on the system log. Further, the techniques use a fuzzy checkpointing scheme that writes only dirty pages to disk, yet minimally interferes with normal processing—all but one of our recovery schemes do not require updaters to even acquire a latch before updating a page. Our log shipping/broadcasting schemes also support concurrent updates to the same page at different sites.     

Enhanced abstract data types in object-relational databases

The explosion in complex multimedia content makes it crucial for database systems to support such data efficiently. This paper argues that the “blackbox” ADTs used in current object-relational systems inhibit their performance, thereby limiting their use in emerging applications. Instead, the next generation of object-relational database systems should be based on enhanced abstract data type (E-ADT) technology. An (E-ADT) can expose the semantics of its methods to the database system, thereby permitting advanced query optimizations. Fundamental architectural changes are required to build a database system with E-ADTs; the added functionality should not compromise the modularity of data types and the extensibility of the type system. The implementation issues have been explored through the development of E-ADTs in Predator. Initial performance results demonstrate an order of magnitude in performance improvements. Received January 1, 1998 / Accepted May 27, 1998     

Thermal diffusivity measurements of some synthetic CaO-Al<Subscript>2</Subscript>O<Subscript>3</Subscript>-SiO<Subscript>2</Subscript> slags

In an attempt to systematize the knowledge of the heat conduction of liquid silicates, the effective thermal diffusivities of some synthetic slags containing CaO, Al₂O₃, and SiO₂ have been measured, using the three-layer laser-flash method on a differential scheme in the temperature range of 1625 to 1825 K. The effective thermal diffusivities measured, which are a combination of the phononic and photonic heat-transfer mechanisms, were found to increase with increasing temperature for all the presently investigated slags. The slag compositions were chosen in such a way that the changes in the effective thermal diffusivities would reflect the changes in the structure of the slags. It was observed that, at a CaO/Al₂O₃ molar ratio of 4.42, an increase of the SiO₂ content had very little effect on the effective thermal diffusivity values. On the other hand, addition of SiO₂ to a slag with the CaO/Al₂O₃ molar ratio of 2.59 resulted in a significant increase in the effective thermal diffusivity. The addition of Al₂O₃ to slags with a constant CaO/SiO₂ molar ratio resulted in a marked increase in the effective thermal diffusivity. Both these trends indicate that there might be an influence of the network formation in silicate melts on the effective thermal diffusivity.     

Screening efficiency of the Hardy–Rand–Rittler (HRR) colour test (4th edn)

This study evaluates the screening efficiency of the Hardy–Rand–Rittler (HRR) 4th edition colour test. This test was also compared with results from the Ishihara test. Thirty-nine subjects with congenital red–green deficiency and 120 colour normal subjects participated in the study. The subjects were shown the Ishihara (concise version, 2001) and the HRR (4th edn) pseudoisochromatic plates. Each plate was viewed for 3?s. A Macbeth Easel lamp was used for illumination (70?foot-candle). The HRR test had 100% sensitivity and the specificity was 63%. The overall efficiency of the HRR test was less than that of the Ishihara. The results also indicated that plate seven of HRR (4th edn) has poor screening efficiency. Thus the HRR is good for identifying colour deficient subjects but a caveat is that it fails too many normals.     

Defect-sealing synthesis of vertically oriented ordered mesoporous silica membranes

Vertically oriented ordered mesoporous silica membranes have been successfully synthesized in our laboratory in the form of silica plugs filling the macron-sized straight pores of hydrophobic track-etched polycarbonate membrane support. However, these membranes have shown gaps between the plugs and support pore wall which make the membranes unfeasible for use. This paper reports on techniques of synthesis of defect-free ordered mesoporous silica membranes by filling the gaps with microporous silica. Here, the elimination of defects is achieved by filling the membrane gaps with an alkoxysilane followed by exposure to humid air to allow controlled hydrolysis and condensation resulting in the formation of microporous silica within the gaps. Molecular probing gas permeation and helium/nitrogen (or oxygen) binary separation tests, coupled with surface characterization methods, show that the final membranes contain ordered mesopores of about 2.7 nm pore diameter, running through the membrane, with gaps sealed by microporous silica having a pore size <0.55 nm.     

Some Thermodynamic Aspects of the Oxides of Chromium

To understand Cr emissions from slag melts to a vapor phase, an assessment of the stabilities of the chromium oxides at high temperatures has been carried out. The objective of the present study is to present a set of consistent data corresponding to the thermodynamic properties of the oxides of chromium, with special reference to the emission of hexavalent chromium from slags. In the current work, critical analysis of the experimental data available and a third analysis in the case of Cr₂O₃ have been carried out. Commercial databases, Fact Sage and ThermoCalc along with NIST-JANAF Thermochemical Tables, have been used for the analysis and comparisons of the results that are presented. The significant discrepancies in the available data have been pointed out. The data from NIST-JANAF Thermochemical Tables have been found to provide a set of consistent data for the various chromium oxides. An Ellingham diagram and the equations for the ΔG° (standard Gibbs free energy change) of formation of CrO _x have been proposed. The present analysis shows that CrO₃(g) is likely to be emitted from slag melts at high oxygen partial pressures.     

Effect of ecofriendly sealing coat against corrosion protection of steel rebars in concrete

Phosphating is one of the most important chemical conversion treatments for steel, mainly to improve corrosion resistance and paint adhesion and as an absorbing layer for waxes, oils, lacquers, etc. However, phosphate coating are crystalline and porous and need a sealing treatment after phosphating. Chromate sealing is a well known practice, and due to its toxicity, development of an ecofriendly sealing treatment is very essential. This paper focuses on the effect of zinc phosphate chemical conversion coating with the addition of nano-SiO₂ to protect the mild steel rebars against corrosion in chloride contaminated concrete. The coated surfaces were characterised by scanning electron microscopy and X-ray diffraction. Corrosion resistances of coated and uncoated rebars were evaluated by anodic polarisation, linear polarisation resistance, Tafel and alternating current impedance spectroscopy and cyclic polarisation technique. The results indicated that the coated rebars have considerably reduced the corrosion rate even in the presence of 3% chloride environments.     

Foaming in Electric Arc Furnace—Part II: Foaming Visualization and Comparison with Plant Trials

The kinetics of slag foaming by limestone particles was studied at 1773?K (1500?°C) with the aid of an X-ray imaging system. Two models were implemented to describe the decrease in foam height with the time on the basis of the lowering of the average temperature and CaO shell formation during decomposition reaction. The energy impact of carbonate additions was studied on an industrial scale in a 100-ton electric arc furnace (EAF). It was found that, in the case of the addition of carbonates after the scrap is completely molten, the heat effects for limestone and dolomite (2255 and 2264?kJ/kg, respectively) were only 70?pct from theoretical values. Comparing these values with similar additions during the scrap melting stage shows that the energy requirements in the case of carbonate additions to steel bath are much smaller. It was found from the trial heats with dolomite addition to the steel bath that the partial substitution of lime by raw dolomite can be made without an increase in energy consumption.